USE [aspnetdb]
GO

-- =============================================
-- Author     :		Lohith Ram D V
-- Create date:         07/mar/2011
-- =============================================

create procedure sp_AddLog(
	@par_text nchar(500))
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
	INSERT INTO  [Log]([Log].[text], [Log].[date])
	VALUES (@par_text, CURRENT_TIMESTAMP);
	/* SET NOCOUNT ON */
	RETURN
